Release 10.1A: OpenEdge Data Management:
SQL Reference

SELECT

Selects the specified column values from one or more rows contained in the tables or views specified in the query expression. The selection of rows is restricted by the WHERE clause. The temporary table derived through the clauses of a select statement is called a result table.

Syntax

SELECT column_list FROM table_list [ WHERE search_condition ] [ GROUP BY grouping_condition ] [ HAVING search_condition ] [ORDER BY ordering_condition ]     [WITH locking_hints ]     [FOR UPDATE update_condition ] ;

column_list

See the COLUMN_LIST clause.

FROM table_list

See the FROM clause.

WHERE search_condition

See the WHERE clause.

GROUP BY grouping_condition

See the GROUP BY clause.

HAVING search_condition

See the HAVING clause.

ORDER BY ordering_condition

See the ORDER BY clause.

WITH locking_hints

See the WITH clause.

FOR UPDATE update_condition

See the FOR UPDATE clause.

Authorization

Must have DBA privilege or SELECT permission on all the tables or views referred to in the query_expression.

Related statements

INSERT, DELETE